Tabela DgDrugActiveSubstance

Definicja tabeli DgDrugActiveSubstance

Name

DgDrugActiveSubstance

Code

DgDrugActiveSubstance

Comment

tabelka laczaca tabelke DgDrug i DgActiveSubstance


Lista kolumn tabeli DgDrugActiveSubstance

Name

Code

DrugActiveSubstID

DrugActiveSubstID

DrugID

DrugID

ActiveSubstanceID

ActiveSubstanceID

Active

Active


Kolumna DrugActiveSubstID tabeli DgDrugActiveSubstance

Definicja kolumny DrugActiveSubstID tabeli DgDrugActiveSubstance

Name

DrugActiveSubstID

Code

DrugActiveSubstID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID


Kolumna DrugID tabeli DgDrugActiveSubstance

Definicja kolumny DrugID tabeli DgDrugActiveSubstance

Name

DrugID

Code

DrugID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID leku


Kolumna ActiveSubstanceID tabeli DgDrugActiveSubstance

Definicja kolumny ActiveSubstanceID tabeli DgDrugActiveSubstance

Name

ActiveSubstanceID

Code

ActiveSubstanceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID substancji aktywnej


Kolumna Active tabeli DgDrugActiveSubstance

Definicja kolumny Active tabeli DgDrugActiveSubstance

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

 


Lista kluczy tabeli DgDrugActiveSubstance

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DgDrugActiveSubstance

Definicja klucza Identifier_1 tabeli DgDrugActiveSubstance

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment